Multiple Selects same table

banbutcher

lo,
i have a table called properties and i am running this select statement:

$querykk = 'SELECT `RecordID`,`Ref_Num`,`Main_Image_Path`,`County` FROM properties'
        . ' where county = "kilkenny"'
        . ' ORDER BY Date_Registered DESC'
        . ' LIMIT 1'
        . ' ';

and i want to do this for a number of counties ie. dublin, cork, limerick... so my question is can i have multiple selects from the same table? then write the results to a table?

Thanks
Richie

Beano

banbutcher wrote: »

lo,
i have a table called properties and i am running this select statement:

$querykk = 'SELECT `RecordID`,`Ref_Num`,`Main_Image_Path`,`County` FROM properties'
        . ' where county = "kilkenny"'
        . ' ORDER BY Date_Registered DESC'
        . ' LIMIT 1'
        . ' ';

and i want to do this for a number of counties ie. dublin, cork, limerick... so my question is can i have multiple selects from the same table? then write the results to a table?

Thanks
Richie

First off what flavour of SQL is this?

I only do TSQL or PL/SQL so my answer is limited to these flavours of SQL. I would replace

where county = "kilkenny"

with

where county in ("kilkenny", "dublin", "cork", "limerick")