Hi all,
When I run the query without the WHERE clause everything shows up fine (data is accurate. However after the WHERE clause is included, the DateNeeded, child’s name and age are all identical. Can someone explain why this is happening?
W10, LO v7.1.3.2, MySQL backend
Hello,
By selecting all from the client and order table there is no determination as to what order records go to what client records so they get associated with all.
You need to use a Join. See this post for more on that → SQL JOIN
With a quick test, cannot see how your result without the Where would work. My result showed two input records in first table and three in second table with six as output - incorrect.
Used to doing it in design view and joining the tables from there. Completely forgot the sql to join the tables.
Thanks, Jody