Only you know the structure of your database. Would guess it would be in customercontactview.
--- In [email protected], "kissthegirlsandmakethemcry" <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' > > I've looked in various tables and cannot seem to find it. > Any help would be greatly appreciated!! >
