View Single Post
  #1 (permalink)  
Old September 18th, 2004, 05:08 AM
koskalgr koskalgr is offline
Registered User
 
Join Date: Sep 2004
Location: , , .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default joining 3 tables

hello
i have these tables

properties
 id
 pname
 areaid
 type

areas
 areaid
 aname

prefectures
 preid
 pname

How can i select the rows from properties that are located in preid=3 (for example) and are of type '2' (again for example)

any help appreciated

Reply With Quote