1. I have selected output from two tables, one is the standard order information from my ecommerce site. The second is called "shipments". They are connected fine, but when there are no entries in the "shipments" table, it does not show any of the data - it basically just skips it. Is there a way I can display all entries even if there is no corresponding data in the "shipments" table?
2. Also in my order information table, the states in the "state" column is represented in numbers that correspond to actual two letter abreviations. In the orders table, the states are these numbers, so it fetches the abreviations from the "states" table. How can I get it to replace the state numbers in the output with the corresponding abbreviations?