SQL Multiple Reference Tables Question

if I Join only one reference table, but does not seem to work for more than one. Is there a way to relate the reference tables in the SELECT part of the query? Thanks for any help James Brown ~| Archives: http

Re: SQL Multiple Reference Tables Question

to specify it. Much of my prior experience was with xBase and once tables were related to each other, all one had to do was specify the field name in the child table and the correct related record was selected. James Brown CFQUERY name=thinglist datasource=mydata SELECT tblThing.ThingKey

Re: SQL Multiple Reference Tables Question - Thanks

This is the answer. Many thanks. James Brown - Original Message - From: Cantrell, Adam [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, February 28, 2003 4:41 PM Subject: RE: SQL Multiple Reference Tables Question This may work, you'll want to look into using

Re: Finding an Odd Number

Use the MOD operator An even Number will return a 0, and odd number will return a 1 Jason Larson wrote: Can someone help me out? I have a cfloop that loops 6 times, I want to be able to be able to output what loop number the current loop is on, and tell if the number is even or odd.

Re: html ideas on this - fixed -

I'd suggest taking a close look at both grammer and spelling. There are a few errors, but I can't tell if they are just typos. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/

Re: Raiser's Edge

rades, etc) software that they sell into the same market. There are a lot more of those than you would guess. you could have a real interesting niche market if you develop internet applications that piggy-back on their stuff. James Brown "Park, Simon" wrote: Has anyone ever connected

Re: Export to Access

So where are the questions? Miriam Hirschman wrote: Hi, Thanks for helping me out. I hop you don't mind that I am emailing you directly. I have 3 questions. Firstly, the file in excel leaves a blank line between each record. Also before the first field there is a square character.

Re: Developer Conference: Hotel Accommodations

which was abour $50 a nite, and each room had a pc with high speed internet access. It was within walking distance of the Metro. James Brown Godfather of Cod, Err I mean Sole. -- Archives: http://www.eGroups.com/list

Re: Excel Import

One rule to remember when designing databases: a "numeric" values that is used only as an identifier, (no math operations will be performed with it) should NEVER be a numeric type field or variable. I run into this all the time with Medical Record Numbers where the position of the digit has