I need help with a query that will pull all FAQs in a selected faqparent.
For instance,
SELECT *
FROM vb_faq
WHERE faqparent LIKE 'vb_ax_autocross'
result vb_faq.faqname
ax_convertibles
ax_faq2
ax_faq3
Then I need to find
vb_phrase.varname (ax_convertibles)
vb_phrase.text
faqtitle (Are convertibles permitted?)
faqtext (Absolutely! This is one of the...)
faqtitle (faq2)
faqtext (faq2)
faqtitle (faq3)
faqtext (faq3)
I'm lost on the join
Thanks and Happy New Year
For instance,
SELECT *
FROM vb_faq
WHERE faqparent LIKE 'vb_ax_autocross'
result vb_faq.faqname
ax_convertibles
ax_faq2
ax_faq3
Then I need to find
vb_phrase.varname (ax_convertibles)
vb_phrase.text
faqtitle (Are convertibles permitted?)
faqtext (Absolutely! This is one of the...)
faqtitle (faq2)
faqtext (faq2)
faqtitle (faq3)
faqtext (faq3)
I'm lost on the join
Thanks and Happy New Year
Comment