I just joined this community and inspired by roaming in it. However, I would like to discuss a problem - I'm having.
I'm developing an application for property management. I've a table with some general columns as well as some specific. For example;
General: [Buy OR Sell] , [Plot no.] , [City]
Specific: [Phase] , [Block] , [Measuring]
Specific fields mean, some property have them and some don't. For example; property 1 has PHASE and BLOCK. While property 2 has only Measuring.
Now, I wanna make a page where all entries for BUY properties - that match with SELL properties, should be listed.
I don't wanna use DISTINCT function of SQL because BUY property may have blank field.
I know, I gonna have an answer for my question by Dani Pros. Thanks in advance.