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!! Quote Link to comment 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... Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.