Re: subquery SQL help

2004-07-17 Thread leegold
I could not get the subquery to work, but the sql below did what I wanted:^) SELECT balloon_rec.* FROM `balloon_rec` LEFT JOIN `balloon_txt` USING (`access_no`) WHERE MATCH (`balloon_txt`.`access_no`,`balloon_txt`.`recs_txt`) AGAINST ('meteorology') On Sat, 17 Jul 2004 12:15:20 -0400, "leegold"

subquery SQL help

2004-07-17 Thread leegold
I tried what's below, seemed OK, so I replaced an "IN" for the "=" in the subquery below because of the subquery's error message. I thought w/"IN" I'd get three (3) records returned as expected. But when I tried "IN" I got my entire DB returned - I don't show that below - it kept scrolling so I ab