Data extraction

[Jai Pierce]

Having not had much of a reply from previous posts I have been experimenting. If I have multiple tables that I need to take details from do I have to be specific in what I want from which tables, because when I

"select * from table_1, table _2, table_3
where table_1.Col_1ID = table_2.Col_2ID
and table_1.COl1ID = table_3.Col3ID;

I get multiple rows with different combinations of all 3 tables, so If I specify which details I want from the tables do I get the specific detail from those tables or do I get the combinations again.

I dont understand how to extract the deatils from all the tables without getting a combination of all tables.

I suspect others dont understand this dilema as well.

Many thanks to someone who can explain clearly this to me and others.

Jai

www.riot-ink.com

Bringing The Tattoo To You!!!!