Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Display null linked records

Display null linked records

Thread began 10/28/2021 5:47 am by birdscreen398247 | Last modified 10/28/2021 8:21 am by birdscreen398247 | 298 views | 1 replies

10/28/2021 8:21 amRay BorduinWebAssist

Try this:

SELECT * FROM PORC_records
LEFT OUTER JOIN aou_list ON PORC_records.species_number = aou_list.SPNO
LEFT OUTER JOIN PORC_classes ON PORC_records.PORC_class = PORC_classes.PORC_class
WHERE PORC_records.record_number = ?

Did this help? Tips are appreciated...

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.