I have 2 tables, CurrentJobs and ItemTickets. Both tables have 'Reps'. I am trying to make query both tables to find out in 1 query what jobs have a certain Rep assigned to them. Here is my query that I have tried so far...
SELECT * FROM CurrentJobs, ItemTickets where CurrentJobs.Rep = 'Jared' && ItemTickets.Rep = 'Jared'
There are 4 rows in each table so I would think it would return 8 total rows, but it returns 16?
I know it's something I don't understand about the join feature, but I tried to study different types of joins and I am even more confused. I need it to return the whole row of data and a lot of the other joins just return the requested field?
Please Help. Thanks!