hi,
i have two tables tbllieferant and tblbranche. in tbllieferant i have 3 fields branche1,branche2,branche3. in these fields i save an id from tblbranche. if i want to join these tables i have a problem if one of the brancheX-fields is null: here my select: select tbllieferant.id, tbllieferant.name, tbllieferant.ort, branche1.bezeichnung&', '&branche2.bezeichnung&', '&branche3.bezeichnung as branchen from tbllieferant join tbladresse on tbllieferant.adresse=tbladresse.id left join tblbranche branche1 on tbllieferant.branche1=branche1.id left join tblbranche branche2 on tbllieferant.branche2=branche2.id left join tblbranche branche3 on tbllieferant.branche3=branche3.id is there any way to solve this problem? greetz Jens _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
