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!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: LiquidSoftware
- Order by date
-
Haveing Problem With Inner Join
Sweet! :D Thank you so much. I'm delivering a version as I type this, you made my day! That was a huge help, thank you! :)- LiquidSoftware
- Post #5
- Forum: ANSI_SQL
-
Haveing Problem With Inner Join
Thanks for the reply! I tried this query, and it returns "Invalid use of Token "Select" in line 4'...I'm using Paradox (with the BDE, for a Delphi application) right now, but will be upsizing it to Interbase, so maybye I'll be able to use it when I move to Interbase. Anyway, do you have any...- LiquidSoftware
- Post #3
- Forum: ANSI_SQL
-
Haveing Problem With Inner Join
SELECT DISTINCT Insurance.InsuranceCode, Insurance.InsuranceID, FeeSchedule.InsuranceID, FeeSchedule.ProcedureID, FeeSchedule.Amount, FeeSchedule.DiscountPercent, FeeSchedule.DiscountAmount FROM Insurance LEFT JOIN FeeSchedule ON Insurance.InsuranceID =...- LiquidSoftware
- Thread
- Replies: 4
- Forum: ANSI_SQL
