At 05:42 AM 27/04/2012, kissthegirlsandmakethemcry wrote: >In Firebird what table contains the email address? > >I'm currently do a select statement, but I can't seem to find the email >address. > >Here is my current select statement: >SELECT so.id, so.num AS sonumber, so.customercontact, so.shiptoname, >so.shiptoaddress, so.shiptocity, so.cost, stateconst.code, so.shiptozip, >countryconst.abbreviation, >carrier.name,carrier.description,shipcarton.freightweight, shipcarton.id as >shipcartionid, shipcarton.cartonnum, customercontactview.contactnum FROM so >LEFT JOIN countryconst ON so.shiptocountryid = countryconst.id >LEFT JOIN stateconst ON so.shiptostateid=stateconst.id >LEFT JOIN carrier ON so.carrierid = carrier.id >LEFT JOIN shipcarton ON so.id = shipcarton.orderid >LEFT JOIN customercontactview ON so.customerid=customercontactview.custid >WHERE so.num='$ORDERNUMBER'
A query does not return fields that are not specified. >I've looked in various tables and cannot seem to find it. >Any help would be greatly appreciated!! Guessing that the column name contains the character string "EMAIL", you could try this (in isql or another query tool): select r.rdb$relation_name, rf.rdb$field_name from rdb$relations r join rdb$relation_fields rf on r.rdb$relation_name = rf.rdb$relation_name where rf.rdb$field_name containing 'EMAIL' Other than that, find the person who designed the database and punch his/her nose for not leaving a data dictionary for future generations! ;-) ./heLen
