happs Posted September 3, 2008 Share Posted September 3, 2008 Hi People. Right - I'm having a NIGHTMARE trying to work this out. I have a table that has, let's say a property letting type and property building type with an id that points to another table that has further details about the specific property... [pre] property id type 1 holiday (id = 1) 1 house (id = 4) 2 residential (id = 2) 2 flat / apartment (id = 3) [/pre] I need a query string that gets the Property ID only ONCE if the type matches, for instance, holiday and house. Any help would be great!! Link to comment https://forums.phpfreaks.com/topic/122504-mysql-join-needed/ Share on other sites More sharing options...
fenway Posted September 3, 2008 Share Posted September 3, 2008 Assuming you mean that each type has its own details table, it's not easy to magically determine the table name of your related table... Link to comment https://forums.phpfreaks.com/topic/122504-mysql-join-needed/#findComment-632808 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.