RE: Is this possible in SQL

e trouble, let it be in my day, that my child may have peace'..." - Thomas Paine, The American Crisis "Let's Roll" - Todd Beamer, Flight 93 -Original Message- From: Andy J [mailto:[EMAIL PROTECTED] Sent: Monday, August 09, 2004 4:22 PM To: CF-T

Re: Is this possible in SQL

Cheers Matt, Worked a charm >I have two tables which I want to query at the same time. I'm thinking >something along the lines of > >SELECT c.categoryid, sc.sub_CategoryId >FROM categories c, sub_category sc >WHERE c.category = '#form.searchVal#' OR sc.sub_Category = >'#form.searchVal#' >LIMIT

RE: Is this possible in SQL

Have you tried union? SELECT. UNION SELECT.   _   From: Andy J [mailto:[EMAIL PROTECTED] Sent: Tuesday, 10 August 2004 11:22 a.m. To: CF-Talk Subject: Is this possible in SQL I have two tables which I want to query at the same time. I'm thinking something along the lines of S

Is this possible in SQL

I have two tables which I want to query at the same time. I'm thinking something along the lines of SELECT c.categoryid, sc.sub_CategoryId FROM categories c, sub_category sc WHERE c.category = '#form.searchVal#' OR sc.sub_Category = '#form.searchVal#' LIMIT 1 But where this is a left join it wil