Catalog - access Data from two data table

[saakshi]

I am trying to create a property listing using catalog ext module. I have two type of catalog first for residential and second for commercial. Now i want show monthly special property from both residential and commercial. How i manage this requirement of my project?

[scare]

I believe the easiest solution would be to create mysql view using union to include properties from both tables and then use listing module to show the results.

[saakshi]

Any other solution ?

[tosca]

I'd rather have created a unique catalog, with a property type field to display only one type (residential or commercial) on the "standard" pages, and keep the opportunity to display both wherever I want.

[thyon]

You have done this correctly -- Create only 1 catalog but have a drop-down that chooses RESIDENTIAL or COMMERCIAL. Then you have a single catalog to run queries against. I prefer to have single catalogs than multiples.