>I need help with an SQL statement. How do I get fields from both tables in the following statement:
>
>Select name, badgeno from usrtbl Where usrid In (Select usrid From usrtbl2)
>
>The usrtbl2 has a department field that I need in my query.

Select usrtbl.name, usrtbl.badgeno, usrtbl2.department  ;
	from usrtbl ;
		JOIN usrtbl2 ON usrtbl.usrid = usrtbl2.usrid