Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Fileds Question in SQL Designer

Status
Not open for further replies.
DBAFrog

DBAFrog

Programmer
Sep 26, 2002
61
US
I hope this is the right forum for this question.

I am building a Query in SQL Designer, I have two (2) tables that have the same Field Names, but different tables, JUVENILE.FIRSTNAME and FAMILY.FIRSTNAME.
I pull the tables into SQL noproblem, but, when I open my CR Form and the DATABASE window I have QUERY table and only ONE (1) FIRSTNAME available.

Do I need to Alias the second FIRSTNAME field to pull it thru, if so, how... OR is there another answer I haven't thought of.

Thanks in advance for any tips or suggestions.

B Smith
DBA_Frog
 
Status
Not open for further replies.

Similar threads

Insulations504
  • Locked
  • Question
Crystal Reports duplicating invoices
Replies
1
Views
593
dgillz
dgillz
dgillz
  • Locked
  • Question
Cannot connect to any ODBC datasource with MS SQL Server data in crystal
Replies
8
Views
944
LyleU
LyleU
Ivan Kok
  • Locked
  • Question
Crystal Reports Runtime causing AS/400 DB2 Database ID to be disabled intermittently
Replies
0
Views
565
Ivan Kok
Ivan Kok
Gary Hnat
  • Locked
  • Question
Crystal SQL Code linking to partial database field entries
Replies
2
Views
576
Gary Hnat
Gary Hnat
sal21
  • Locked
  • Question
create report without database in vb 6.0 and recordset
Replies
0
Views
595
sal21
sal21

Part and Inventory Search

Sponsor

Back
Top