Poor database design I suppose, but never the less I need to retrieve
FIELD -this-, -that-, -the other- from TABLE foo and
FIELD -pphone- from TABLE -bar-.
For example a record set of McDonalds restaurants in different cities.
Where a particular restaurants phone# is not known, I pull the corporate phone #(pphone) from a primary table where they both have the same ID #
I can't get the query syntax right.
I have a WHILE statement listing out the Variables into a table, and it doesn't seem to pull the primary phone number no matter what I try. I was taught Access, but can't get a relationship formed with Mysql, otherwise I would have designed it right to begin with.
Any ideas?
digitaldancer 0 Newbie Poster
ShawnCplus 456 Code Monkey Team Colleague
Show your current query and we can walk you through what to fix.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.