Posted on 2002-04-15
I have a union query and need it have the combined items into a list box. I can only get the items from the SQL statement prior to the UNION part.
Sql = "SELECT EquipmentType FROM tbl_Equipment " _
& "Where EquipmentType <> Null And Trim(EquipmentType) <> "" " _
& "Union " _
& "SELECT fld_EqType FROM tbl_Inventory_Equipment " _
& "WHERE fld_EqType <> NULL and TRIM(fld_EqType) <> "" ;"
g_rst.CursorLocation = adUseClient
g_rst.Open sSqlx, g_conn, adOpenKeyset, adLockOptimistic
Do While Not g_rst.EOF
Also, using the example above, how can I union three tables?