Selecting from a table then a record
Posted 28 June 2003 - 03:07 PM
I want to select data depending on two things
so i select from the db (clients) then i want to display the data in the area (area) and then select the business.
The area andbusiness are bth tables in the clients dataabse
Can anyone help?
is this is
SELECT * FROM clients WHERE business = \'self\', WHERE area = \'south ayrshire\'\"
Posted 28 June 2003 - 08:28 PM
Shouldn\'t it be:
SELECT * FROM clients WHERE business = \'self\' AND area = \'south ayrshire\'\"
Posted 28 June 2003 - 08:30 PM
I used and in lower case
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users