Are you looking for:
SELECT table1.name, table2.subject
FROM table1, table2
WHERE table1.id=table2.student_id
Good Luck,
Dennis
**********************************************
Beridney Computer Services
http://www.beridney.com
----- Original Message -----
From: "Jamie Burns" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, August 05, 2001 2:25 PM
Subject: quickie!
hi..
can someone tell me how i get the data from two tables, where table1 will
have one row, and table2 will have many rows?
eg:
================================
table1:
id name
1 barney
2 fred
3 wilma
table2:
id student_id subject
1 1 english
1 1 cookery
1 1 maths
1 1 science
1 2 woodwork
1 3 cookery
================================
do i have to use two queries to get all this data out in usable form?
thanks,
jamie.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php