For example you want two tables that have a column that has an identical id and that id you want to print out in another table. how will you code it?
Tonkz 0 Light Poster
Recommended Answers
Jump to PostInner Join (id is foreign key)
SELECT * FROM table1 t1, table2 t2 WHERE t1.id = t2.id
Left Outer Join (id is foreign key)
SELECT * FROM table1 t1, table2 t2 WHERE t1.id *= t2.id
All 4 Replies
Airshow 416 WiFi Lounge Lizard Team Colleague
Tonkz 0 Light Poster
mail2saion 14 Posting Whiz in Training
Stylish 1 Junior Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.