Jump to content
  • 0

Is It Possible To Create A View Using Custom Sql?


webmanager
 Share

Question

Hello all. I am looking to create a view that pulls from two tables, however my caveat is that I am looking to pull random records from the second table. I would like to know if it is possible to create more robust views by directly manipulating the SQL behind it.

 

Thanks,

 

Mack

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0

Ok, so apparently I have stumped the group. My next question then is, can someone explain how I can insert "native" ads into my search form results. My employer is looking to have random paid write ups for various businesses appear in the search results from our community service guide.

 

So essentially, a reader will surf to the guide page and do a search for say post offices in one of the local counties. When the results come up she wants to see mixed in among the list of post offices, a random write up we have produced for a paid ad. Her idea is to have it blend in like it is a part of the search results.

 

My original idea was to have the editors put thier write ups into a second table that I could merge with the table that contains the actual community information using a view that would pull in records randomly from the "write ups" table but it looks like from the deafening silence that no one knows how to achieve that so now I feel stuck.

 

Does anyone have a suggestion for me to help achieve this project goal?

 

Thanks,

 

Mack

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...