+ Reply to Thread
Results 1 to 9 of 9

Using CREATE VIEW SQL

  1. #1
    Forum Contributor
    Join Date
    12-30-2012
    Location
    Israel
    MS-Off Ver
    2007, 2016
    Posts
    639

    Using CREATE VIEW SQL

    Hi, I've got two columns, municipality (string) and population (number). And I need to create virtual table which combines these two columns.
    I was thinking to do it like this, but it doesn't seem to work. Any idea?
    Please Login or Register  to view this content.
    Please * if you like the answer

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,626

    Re: Using CREATE VIEW SQL

    Couldn't you use a query?
    If posting code please use code tags, see here.

  3. #3
    Forum Contributor
    Join Date
    12-30-2012
    Location
    Israel
    MS-Off Ver
    2007, 2016
    Posts
    639

    Re: Using CREATE VIEW SQL

    I guess you're right . But the conspect of virtual tables is new to me, so I'll be happy to understand the syntax. Maybe it doens't work in MS ACCESS?

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,626

    Re: Using CREATE VIEW SQL

    Access doesn't have views.

    What is it you are trying to do anyway?

    What's the purpose of this 'temporary' table?

  5. #5
    Forum Contributor
    Join Date
    12-30-2012
    Location
    Israel
    MS-Off Ver
    2007, 2016
    Posts
    639

    Re: Using CREATE VIEW SQL

    Thank you Norie, that's good to know but what's the meaning that Access doesn't have views?

    This "column" (or virtual column) will be used in the where statement, like that:
    Please Login or Register  to view this content.

  6. #6
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,218

    Re: Using CREATE VIEW SQL

    A view isn't a column - I think you're getting a bit mixed up.

    I think you want something like:

    Please Login or Register  to view this content.

  7. #7
    Forum Contributor
    Join Date
    12-30-2012
    Location
    Israel
    MS-Off Ver
    2007, 2016
    Posts
    639

    Re: Using CREATE VIEW SQL

    Thank you Kyle it works. And the critical line is this:
    municipality & ' ' & population
    The syntax is different from MySQL..

    Back to my question: specifically do we have equivalent to CREATE VIEW?

  8. #8
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,218

    Re: Using CREATE VIEW SQL

    No idea, I don't use access - it is missing a lot of normal database features.

    I think most things are done via 'Queries'

  9. #9
    Forum Contributor
    Join Date
    12-30-2012
    Location
    Israel
    MS-Off Ver
    2007, 2016
    Posts
    639

    Re: Using CREATE VIEW SQL

    Ok PM you somthing. Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Lookup data from two tables to create a 3rd view
    By Ruthie in forum Excel General
    Replies: 4
    Last Post: 12-15-2011, 05:55 AM
  2. How to create a Custom View 'button'?
    By Cheshire in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-07-2009, 03:29 PM
  3. How can I create shortcuts for the view function in Excel?
    By AJB in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-11-2006, 11:25 AM
  4. How to create a button to switch to a custom view
    By Turquoise_dax in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-15-2006, 02:55 PM
  5. Create view using data autofilter
    By Arleigh Birchler in forum Excel General
    Replies: 2
    Last Post: 05-19-2005, 04:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1