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"
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