User Profile

Collapse

Profile Sidebar

Collapse
islandgal
islandgal
Last Activity: Sep 1 '10, 01:03 AM
Joined: May 17 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • islandgal
    started a topic compute and update query
    in C Sharp

    compute and update query

    --
    -- Table structure for table borrower
    --
    DROP TABLE IF EXISTS borrower;
    CREATE TABLE borrower (
    brw_num int(11) NOT NULL default '0',
    brw_lname varchar(15) default NULL,
    brw_fname varchar(15) default NULL,
    brw_initial varchar(1) default NULL,
    brw_areacode varchar(3) default NULL,
    brw_phone varchar(8) default NULL,
    PRIMARY KEY (brw_num)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;...
    See more | Go to post
    • islandgal
      replied to how to write queries in SQL
      in Software Development
      thanks Jim,

      i cannot execute the first query...there is an error

      "Syntax error in Join operation"

      the second works fine!!!!

      thanks
      See more | Go to post

        Leave a comment:

      • islandgal
        started a topic how to write queries in SQL
        in Software Development

        how to write queries in SQL

        --
        -- Table structure for table borrower
        --
        DROP TABLE IF EXISTS borrower;
        CREATE TABLE borrower (
        brw_num int(11) NOT NULL default '0',
        brw_lname varchar(15) default NULL,
        brw_fname varchar(15) default NULL,
        brw_initial varchar(1) default NULL,
        brw_areacode varchar(3) default NULL,
        brw_phone varchar(8) default NULL,
        PRIMARY KEY (brw_num)
        ) ENGINE=InnoDB...
        See more | Go to post
        No activity results to display
        Show More
        Working...