I have two identical tables,Table1 and Table2. Each have two fields, name and state…
The first table has values John and Florida, the second table has values Sally and Florida.
I want to write a join statement and display the results on one line of a listbox.in each table.
My intended output is a one row listbox that states John, Sally, Florida. Aka show me all instances where two people share the same state.
Can anyone help me with the join statement, and more importantly, how do I structure the list box?
What I have so far…
SQL = SELECT * from Table1 inner join Table2 on Table1.state = Table2.state where Table1.state = Table2.state;
With a two column listbox of name and state, I get:
How do I combine the results into a single three column listbox…? (Assuming my join is correct)
Thanks in advance… -John