select from two tables
Posted on 2005-04-06
ok, so i have two tables, table 2 has the record in it, and table 1 has the keywords. they are linked by MARKID... notice how one record can have more then one keyword. is there a way, in one query, to return the results AND the keywords....
SELECT * FROM table1 t1, table2 t2 WHERE t1.MARKID = t2.MARKID
i want to see
george apple grape
or do i have to do it with two querys? one where i select all the records, and the go thru and select all keywords for eachr record?