Basically Im playing around with databases in SQL Server to help learn the language. Is there anything wrong with this command? Basically I have two tables from different table groups on the same database.
Essentially there is one table in each, for my problem's sake, tblA, tblB on groups A and B.
If you are talking about Filegroups in a database, then you do not need to specify that in the query. Only the schema name, and possibly the database name would need to be specified to qualify a table. Try this:
SELECT tblA.LastName AS ALastName,
tblA.FirstName AS AFirstName,
tblB.LastName AS BLastName,
tblB.FirstName AS BFirstName
FROM tblA JOIN
tblB ON tblA.LastName = tblB.LastName