Hi,
I am creating a query dynamically and its working. Most important part is in where condition
select noun_english.noun_id, noun_english.a_te_noun_singular,noun_english.a_te_noun_plural,noun.a_pic_image,noun_spanish.a_te_noun_singular,noun_spanish.a_te_noun_plural,noun_spanish.a_au_audio_singular,noun_spanish.a_au_audio_plural,noun_spanish.a_au_audio_examples,noun_spanish.a_te_examples,noun_spanish.b_te_synonyms_id,noun_spanish.c_au_qadeer2,noun_italian.a_te_noun_singular,noun_italian.a_te_noun_plural,noun_italian.a_au_audio_singular,noun_italian.a_au_audio_plural,noun_italian.a_au_audio_examples,noun_italian.a_te_examples,noun_italian.b_te_synonyms_id,noun_italian.c_au_qadeer2
from noun_english,noun,noun_spanish,noun_italian
where noun_english.noun_id=noun.noun_id and noun.noun_id=noun_spanish.noun_id and noun_spanish.noun_id=noun_italian.noun_id
This query work fine and get records but only those records which are present all the tables as where condition is as noun_id of ist tables is equal to noun_id of second table and so on .
Here i want to show all max records mean if one of the table has 250 records and other not much then the result set show 250 record since field data is null of ohter tables because this record is not present.
Note: I don't know which one has max records.
Thanks
